[dbo].[BAEOrderProductGetAll]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderProductGetAll

Properties
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

SQL Script

create procedure [dbo].[BAEOrderProductGetAll] as
SELECT *
FROM OrderProduct AS op JOIN Product AS p ON op.ProductCode COLLATE database_default = p.PRODUCT_CODE COLLATE database_default WHERE p.PROD_TYPE = 'SALES'

ORDER BY OrderProductID;

GO

Uses

[dbo].[OrderProduct]
[dbo].[Product]
dbo